create or replace trigger DROPENROLL
after delete on revenroll
for each row
begin
	update revclass
	set currentenroll=currentenroll-1
	where revclass.classnumber=:old.classnumber;

exception
	when no_data_found then 
		DBMS_OUTPUT.PUT_LINE('No data found');
	when others then
		DBMS_OUTPUT.PUT_LINE('Error-' || SQLERRM);

end;
/
